Manufacturing - Production Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
EntryDate datetime 8 getdate()    
OrderNo pTransID 8      
SeqNo int 4      
Source varchar 2   Transaction Source 1 = Adjustment, 2 = Machine, 3 = Labor, 4 = Subcontracted, 5 = Inventory, 6 = Machine Overhead, 7 = Labor Overhead, 8 = PerPiece Overhead, 9 = Order Overhead, 10 = Labor Setup
GLAccountDebit pGlAcct 255      
GLAccountCredit pGlAcct 255      
Amount pDecimal 13 0    
PostedYN bit 1 0    
GlPeriod smallint 2      
FiscalYear smallint 2      
CF xml -1      
ts timestamp 8      
ReleaseNo int 4      
ReqId int 4      
TransDate datetime 8 getdate()    
TransId int 4      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
SeqNo int 4      
TransId int 4      
TransDate datetime 8      
ComponentId pItemID 24      
LocId pLocID 10      
Qty pDecimal 13      
UOM pUom 5      
UOMBase pUom 5      
ConvFactor pDecimal 13      
ActualScrap pDecimal 13      
UnitCost pDecimal 13      
VarianceCode nvarchar 10      
AssembledYn int 4      
SubAssemblyTranType smallint 2   Subassembly Transaction Type 1 = Pulled from Stock, 2 = Qty Assembled, -1 = Moved to Stock
GlPeriod smallint 2      
FiscalYear smallint 2      
HistSeqNum int 4      
QtySeqNum int 4      
CF xml -1      
ts timestamp 8      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
Cmnt pDescription 255      
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
EntryNum int 4      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
HistSeqNum int 4      
HistSeqNumExt int 4      
LotNum pLotNum 16      
PostRun pPostRun 14      
QtyFilled pDecimal 13 0    
QtySeqNum int 4      
QtySeqNumExt int 4      
SeqNum int 4      
TransId int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
PostRun pPostRun 14      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13      
CostUnitFgn pDecimal 13      
PriceUnit pDecimal 13      
PriceUnitFgn pDecimal 13      
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
ts timestamp 8      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
Column Name Column Type Length Default Value Description Enumeration
ComponentId pItemID 24      
LocId pLocID 10      
Notes nvarchar max      
TransId int 4      
UOMBase pUom 5      
PostRun pPostRun 14      
ComponentType tinyint 1   Component Type 0 = Assembly, 1 = Routing, 2 = Subassembly, 3 = Stocked Subassembly, 4 = Material, 5 = ByProduct, 6 = Subcontract
LeadTime int 4      
RequiredDate datetime 8      
EstQtyRequired pDecimal 13      
EstScrap pDecimal 13      
UOM pUom 5      
ConvFactor pDecimal 13      
CostGroupId nvarchar 6      
UnitCost pDecimal 13      
Status tinyint 1   Production Order Requirement Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
QtySeqNum int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
OrderNo pTransID 8      
AssemblyId pItemID 24      
RevisionNo nvarchar 3      
Planner nvarchar 20      
Routing tinyint 1   Routing Type 1 = Primary, 2 = Secondary
Status tinyint 1   Production Order Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
EstStartDate datetime 8      
EstCompletionDate datetime 8      
CustId pCustID 10      
SalesOrder pTransID 8      
PurchaseOrder nvarchar 25      
UOM pUom 5      
Qty pDecimal 13      
OrderCode nvarchar 10      
CF xml -1      
ts timestamp 8      
LocId pLocID 10      
Notes nvarchar max      
OrderSource int 4   Order Source 0 = Manual, 1 = Imported, 2 = Generated
Priority int 4 0    
ReleaseId int 4      
ReleaseNo int 4      
Column Name Column Type Length Default Value Description Enumeration
Description pDescription 255      
ParentId int 4      
ReleaseId int 4      
ReqId int 4      
Step int 4      
TransId int 4      
PostRun pPostRun 14      
IndLevel int 4      
Type tinyint 1   Requirement Type 0 = Assembly, 1 = Routing Step, 2 = Subassembly, 3 = Stocked Subassembly, 4 = Component, 5 = Byproduct, 6 = Subcontracted, 7 = Miscellaneous, 8 = Media
BLT int 4      
QTY pDecimal 13      
ReqSeq int 4      
EstProcessTime bigint   0    
EstStartDate datetime        
EstCompletionDate datetime        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId int 4      
SeqNo int 4      
TransDate datetime 8      
QtySent pDecimal 13      
QtyReceived pDecimal 13      
QtyScrapped pDecimal 13      
UnitCost pDecimal 13      
VendorId pVendorID 10      
VendorDocNo nvarchar 30      
VarianceCode nvarchar 10      
GlPeriod smallint 2      
FiscalYear smallint 2      
CF xml -1      
ts timestamp 8      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
TransId int 4      
LeadTime int 4      
RequiredDate datetime 8      
OperationId nvarchar 10      
EstQtyRequired pDecimal 13      
EstPerPieceCost pDecimal 13      
CostGroupId nvarchar 6      
Status tinyint 1   Production Order Requirement Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
DefaultVendorId pVendorID 10      
Description pDescription 255      
CF xml -1      
ts timestamp 8      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
EmployeePayRate pDecimal 13      
Notes nvarchar max      
TransId int 4      
PostRun pPostRun 14      
SeqNo int 4      
TransDate datetime 8      
MachineSetup pDecimal 13      
MachineSetupIn smallint 2   Unit of Time - Machine Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachineRun pDecimal 13      
MachineRunIn smallint 2   Unit of Time - Machine Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborSetup pDecimal 13      
LaborSetupIn smallint 2   Unit of Time - Labor Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
Labor pDecimal 13      
LaborIn smallint 2   Unit of Time - Labor Time 1 = Hours, 60 = Minutes, 3600 = Seconds
QtyProduced pDecimal 13      
QtyScrapped pDecimal 13      
VarianceCode nvarchar 10      
BeginTime datetime 8      
EndTime datetime 8      
Hours int 4      
Mins int 4      
PostedPayrollYn bit 1      
GlPeriod smallint 2      
FiscalYear smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
LeadTime int 4      
RequiredDate datetime 8      
OperSupervisor nvarchar 20      
LaborSetupTypeId nvarchar 10      
LaborSetupEst int 4      
LaborEst int 4      
LaborPctOvhd pDecimal 13      
FlatAmtOvhd pDecimal 13      
PerPieceOvhd pDecimal 13      
MachPctOvhd pDecimal 13      
HourlyCostFactorMach pDecimal 13      
PerPieceCostLbr pDecimal 13      
HourlyRateLbr pDecimal 13      
MachineSetupEst int 4      
MachineRunEst int 4      
QtyProducedEst pDecimal 13      
QtyScrappedEst pDecimal 13      
QueueTimeEst int 4      
WaitTimeEst int 4      
MoveTimeEst int 4      
OverlapYn bit 1      
Status tinyint 1   Production Order Process Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
WSeqNo int 4      
MSeqNo int 4      
LSeqNo int 4      
CF xml -1      
ts timestamp 8      
LaborCostGroupId varchar 6      
LaborSetupCostGroupId varchar 6      
LaborTypeId varchar 10      
MachineCostGroupId varchar 6      
MachineGroupId varchar 10      
Notes nvarchar max      
OperationId varchar 10      
ScheduleId varchar 10      
TransId int 4      
WorkCenterCostGroupId varchar 6      
WorkCenterId varchar 10      
OperatorCount tinyint 1 0    
Column Name Column Type Length Default Value Description Enumeration
ComponentId pItemID 24      
LocId pLocID 10      
Notes nvarchar max      
TransId int 4      
SeqNo int 4      
TransDate datetime 8      
Qty pDecimal 13 0    
UOM pUom 5      
ActualScrap pDecimal 13 0    
UnitCost pDecimal 13 0    
VarianceCode nvarchar 10      
AssembledYn int 4      
SubAssemblyTranType smallint 2 0 Subassembly Transaction Type 1 = Pulled from Stock, 2 = Qty Assembled, -1 = Moved to Stock
GlPeriod smallint 2      
FiscalYear smallint 2      
HistSeqNum int 4      
QtySeqNum int 4      
CF xml -1      
ts timestamp 8      
PostedYn bit 1 0    
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
SeqNum int 4      
Cmnt pDescription 255      
CostUnit pDecimal 13 0    
EntryNum int 4      
ExtLocA int 4      
ExtLocB int 4      
HistSeqNum int 4      
HistSeqNumExt int 4      
LotNum pLotNum 16      
QtyFilled pDecimal 13 0    
QtySeqNum int 4      
QtySeqNumExt int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
TransId int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnit pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
*CostUnitACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
ComponentId pItemID 24      
LocId pLocID 10      
Notes nvarchar max      
TransId int 4      
ComponentType tinyint 1   Component Type 0 = Assembly, 1 = Routing, 2 = Subassembly, 3 = Stocked Subassembly, 4 = Material, 5 = ByProduct, 6 = Subcontract
LeadTime int 4 0    
RequiredDate datetime 8      
EstQtyRequired pDecimal 13 0    
EstScrap pDecimal 13 0    
UOM pUom 5      
CostGroupId nvarchar 6      
UnitCost pDecimal 13 0    
Status tinyint 1 0 Production Order Requirement Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
QtySeqNum int 4      
LinkSeqNum int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Cmnt pDescription 255      
ExtLocA int 4      
ExtLocB int 4      
LotNum pLotNum 16      
QtyFilled pDecimal 13 0    
QtyRequired pDecimal 13 0    
QtySeqNumExt int 4      
SeqNum int 4      
TransId int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
OrderNo pTransID 8      
AssemblyId pItemID 24      
RevisionNo nvarchar 3      
LocId pLocID 10      
Planner nvarchar 20      
GLAcctWIP pGlAcct 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
OrderNo pTransID 8      
Routing tinyint 1 0 Routing Type 1 = Primary, 2 = Secondary
Status tinyint 1 0 Production Order Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
EstStartDate datetime 8      
EstCompletionDate datetime 8      
CustId pCustID 10      
SalesOrder pTransID 8      
PurchaseOrder nvarchar 25      
UOM pUom 5      
Qty pDecimal 13 -1    
OrderCode nvarchar 10      
CF xml -1      
ts timestamp 8      
Notes nvarchar max      
OrderSource int 4 0 Production Order Source 0 = Manual, 1 = Imported, 2 = Generated
Priority int 4 0    
ReleaseNo int 4      
Column Name Column Type Length Default Value Description Enumeration
Description pDescription 255      
ParentId int 4      
ReleaseId int 4      
ReqId int 4      
Step int 4      
TransId int 4      
IndLevel int 4      
Type tinyint 1 0 Requirement Type 0 = Assembly, 1 = Routing Step, 2 = Subassembly, 3 = Stocked Subassembly, 4 = Component, 5 = Byproduct, 6 = Subcontracted, 7 = Miscellaneous, 8 = Media
BLT int 4 0    
QTY pDecimal 13 -1    
ReqSeq int 4 0    
EstProcessTime bigint   0    
EstStartDate datetime        
EstCompletionDate datetime        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
VendorId pVendorID 10      
SeqNo int 4      
TransDate datetime 8      
QtySent pDecimal 13 0    
QtyReceived pDecimal 13 0    
QtyScrapped pDecimal 13 0    
UnitCost pDecimal 13 0    
VendorDocNo nvarchar 30      
VarianceCode nvarchar 10      
GlPeriod smallint 2      
FiscalYear smallint 2      
Notes nvarchar max      
CF xml -1      
ts timestamp 8      
PostedYn bit 1 0    
Column Name Column Type Length Default Value Description Enumeration
CostGroupId varchar 6      
DefaultVendorId pVendorID 10      
Description pDescription 255      
Notes nvarchar max      
OperationId varchar 10      
TransId int 4      
LeadTime int 4      
RequiredDate datetime 8      
EstQtyRequired pDecimal 13 0    
EstPerPieceCost pDecimal 13 0    
Status tinyint 1   Production Order Requirement Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
LinkSeqNum int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
EmployeeId pEmpID 11      
EmployeePayRate pDecimal 13      
Notes nvarchar max      
SeqNo int 4      
TransDate datetime 8      
MachineSetup pDecimal 13 0    
MachineSetupIn smallint 2 1 Unit of Time - Machine Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachineRun pDecimal 13 0    
MachineRunIn smallint 2 1 Unit of Time - Machine Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborSetup pDecimal 13 0    
LaborSetupIn smallint 2 1 Unit of Time - Labor Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
Labor pDecimal 13 0    
LaborIn smallint 2 1 Unit of Time - Labor Time 1 = Hours, 60 = Minutes, 3600 = Seconds
QtyProduced pDecimal 13 0    
QtyScrapped pDecimal 13 0    
VarianceCode nvarchar 10      
BeginTime datetime 8      
EndTime datetime 8      
Hours int 4      
Mins int 4      
PostedPayrollYn bit 1 0    
GlPeriod smallint 2      
FiscalYear smallint 2      
CF xml -1      
ts timestamp 8      
PostedYn bit 1 0    
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
ScheduleId varchar 10      
OperationId varchar 10      
WorkCenterCostGroupId varchar 6      
WorkCenterId varchar 10      
LeadTime int 4 0    
RequiredDate datetime 8      
OperSupervisor nvarchar 20      
LaborSetupTypeId nvarchar 10      
LaborSetupEst int 4 0    
LaborEst int 4 0    
LaborPctOvhd pDecimal 13 0    
FlatAmtOvhd pDecimal 13 0    
PerPieceOvhd pDecimal 13 0    
MachPctOvhd pDecimal 13 0    
HourlyCostFactorMach pDecimal 13 0    
PerPieceCostLbr pDecimal 13 0    
HourlyRateLbr pDecimal 13 0    
MachineSetupEst int 4 0    
MachineRunEst int 4 0    
QtyProducedEst pDecimal 13 0    
QtyScrappedEst pDecimal 13 0    
QueueTimeEst int 4 0    
WaitTimeEst int 4 0    
MoveTimeEst int 4 0    
OverlapYn bit 1 0    
Status tinyint 1 0 Production Order Requirement Status 0 = New, 1 = Planned, 2 = Firm Planned, 3 = Released, 4 = In Process, 5 = Production Hold, 6 = Completed, 7 = Canceled
WSeqNo int 4 -9999    
MSeqNo int 4 -9999    
LSeqNo int 4 -9999    
LaborCostGroupId varchar 6      
LaborSetupCostGroupId varchar 6      
LaborTypeId varchar 10      
MachineCostGroupId varchar 6      
MachineGroupId varchar 10      
OperatorCount tinyint 1 0    
Notes nvarchar max      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
VarianceCode nvarchar 10      
ActiveYN bit 1      
Descr pDescription 255      
CF xml -1      
ts timestamp 8